﻿CREATE TABLE [dbo].[ScribeLocation]
(
	[ScribeID] INT NOT NULL ,
	[LocationID] INT NOT NULL ,
	CONSTRAINT FK_ScribeLocation_Scribe FOREIGN KEY ([ScribeID]) REFERENCES Scribe(Id),
	CONSTRAINT FK_ScribeLocation_Location FOREIGN KEY ([LocationID]) REFERENCES Location(Id), 
    CONSTRAINT [PK_ScribeLocation] PRIMARY KEY ([ScribeID], [LocationID]),
)

